MINUTE

Returns the minute (0-59) from a time value.

Syntax

MINUTE(time)

Arguments

• time: The time from which to extract the minute.

Example

MINUTE("14:30:00") → Returns 30
MINUTE(A1) → Returns the minute from the time in cell A1